package model;

import java.util.ArrayList;
import java.util.List;

import com.et.ar.ActiveRecordBase;
import com.et.ar.annotations.Column;
import com.et.ar.annotations.Id;
import com.et.ar.annotations.NotEmpty;
import com.et.ar.annotations.Table;
import com.et.ar.annotations.Unique;
import com.et.ar.exception.ActiveRecordException;
import com.et.mvc.ViewRendererClass;

/**
 * @author zlb
 * @date 2011-3-20 下午03:43:16
 * @desc 用户登录
 * 
 */

@Table(name = "user_list")
public class User_list extends ActiveRecordBase {
	@Id
	private Integer user_id;
	@Column
	private String user_jh;
	@Column
	private String user_password;
	@Column
	private String user_name;
	@Column
	private String user_sfzh;
	@Column
	private String user_zw;
	@Column
	private String user_company;
	@Column  
	private String user_bs;
	@Column
	private String user_phone;
	@Column
	private Integer user_lrr;
	@Column
	private String user_lrr_company;
	@Column
	private String user_time;
	public Integer getUser_id() {
		return user_id;
	}
	public void setUser_id(Integer user_id) {
		this.user_id = user_id;
	}
	public String getUser_jh() {
		return user_jh;
	}
	public void setUser_jh(String user_jh) {
		this.user_jh = user_jh;
	}
	public String getUser_password() {
		return user_password;
	}
	public void setUser_password(String user_password) {
		this.user_password = user_password;
	}
	public String getUser_name() {
		return user_name;
	}
	public void setUser_name(String user_name) {
		this.user_name = user_name;
	}
	public String getUser_sfzh() {
		return user_sfzh;
	}
	public void setUser_sfzh(String user_sfzh) {
		this.user_sfzh = user_sfzh;
	}

	public String getUser_company() {
		return user_company;
	}
	public void setUser_company(String user_company) {
		this.user_company = user_company;
	}
	public String getUser_bs() {
		return user_bs;
	}
	public void setUser_bs(String user_bs) {
		this.user_bs = user_bs;
	}
	public String getUser_phone() {
		return user_phone;
	}
	public void setUser_phone(String user_phone) {
		this.user_phone = user_phone;
	}
	public Integer getUser_lrr() {
		return user_lrr;
	}
	public void setUser_lrr(Integer user_lrr) {
		this.user_lrr = user_lrr;
	}
	
	public String getUser_lrr_company() {
		return user_lrr_company;
	}
	public void setUser_lrr_company(String user_lrr_company) {
		this.user_lrr_company = user_lrr_company;
	}
	public String getUser_time() {
		return user_time;
	}
	public void setUser_time(String user_time) {
		this.user_time = user_time;
	}
	
	public String getUser_zw() {
		return user_zw;
	}
	public void setUser_zw(String user_zw) {
		this.user_zw = user_zw;
	}
	
	public List getUserPrivs(String user_priv) throws Exception {
		List<V_user_priv> l_userpriv = findBySql(V_user_priv.class,
				"select * from v_user_priv where status = 0 and priv_no=? order by menu_id,SUB_ID",
				new Object[]{user_priv});
		//select * from v_user_priv where 
		return l_userpriv;
	}
	
	
}
